Using DBtools.h++ for Portable Maintainable Database Applications

Outline

Day 1:

An introduction to the course

• Course goal: Creating understandable and portable database programs
• Course Overview

Rogue Wave Paradigms and DBtools.h++ Overview

• The Producer / Product Paradigm
• Reference Semantics / Reference Counting
• Data Model

Tools.h++ Basics and DBtools.h++ Basics

• Data Retrieval Encapsulations
• Multiple Result Sets
• LAB 1

Day 2:

Error Model

• Object Status
• Callback Functions
• Exceptions
• LAB 2

Selection Encapsulation

• Selectors
• Expressions
• LAB 3

Cursors

• LAB 4

Day 3:

Inserting, Deleting, and Updating

• LAB 5

Managing Connections and Transactions

• Connection Objects
• Transactions
• Isolation Levels
• LAB 6

Day 4:

Data Definition Language Encapsulation

• Tables
• Indices
• Views

Stored Procedures

• Result Sets
• Parameters
• Creating

Blobs

Memory Tables

• Value Objects
• Memory Tables
• Template Based Memory Tables
• LAB 7

Day 5:

Persisting Objects

• Relational to OO Mapping Schemes
• Flat vs. Complex objects
• Factories
• LAB 8

Using DBtools.h++ Most Effectively

• Using Tools from Tools.h++
• Virtual Stream Blobs
• Encapsulating DBtools.h++
• LAB 9